Hi all,

Using variables to name my output files, I've had success with these in Solution Builder / Action / Save file name field

1. to save as filename_yyyymmddhhmmss.pdf
filename_%{(Year(Date) & Right("0" & Month(Date), 2) & Right("0" & Day(Date), 2) & Right("0" & Hour(Now), 2) & Right("0" & Minute(Now), 2) & Right("0" & Second(Now), 2))}%.pdf

2. to save as filename_yyyymmdd.pdf
filename_%{(Year(Date) & Right("0" & Month(Date),2) & Right("0" & Day(Date),2))}%.pdf

With reference & thanks to poster PHV over at Tek-Tips www.tek-tips.com/viewthread.cfm?qid=979415

Cheers,
Brad

Does this not work in the free version? I'm trying to use the first day of this month, and it keeps getting:

Conversion from string "%{DateSerial(DatePart("yyyy"" to type 'Date' is not valid.

Am I missing an escape character?

Yeah, VBScript support is a pro feature option.

Thanks!
Brian

swordfrog wrote:
From my own testing the above two examples don't actually work, as the & symbol breaks the parsing of the RRD file, however I've managed to create the below lines to produce similar filenames:

Today's date, with leading zero, in the format YYYY-MM-DD
%{DatePart("yyyy",date)}%-%{Right("0" + cstr(DatePart("m",date)), 2)}%-%{Right("0" + cstr(DatePart("d",date)), 2)}%

Yesterday's date, with leading Zero, in the format YYYY-MM-DD
%{DatePart("yyyy",DateAdd("d", -1, date))}%-%{Right("0" + cstr(DatePart("m",DateAdd("d", -1, date))), 2)}%-%{Right("0" + cstr(DatePart("d",DateAdd("d", -1, date))), 2)}%

I'm looking to get the last day of the month, 3 months ahead.
So if today is 10/26/16, I need the date of 1/31/17
I cannot figure out the VB script examples

Dan231 wrote: Hi Dan,
I think the below should do what you want. It returns the date in format YYYY-MM-DD of the last day of three months from now. I've used this format as it's what I had to hand, I've explained what I've done though, so hopefully you can work out how to adjust the format yourself, the below notes should also help explain how my examples above work.

We get this by first finding the year in three months:year() returns only the year from the date passed to it, DateAdd() is used to add 3 (parameter 2) months (parameter 1) to the current date (parameter 3)

We then do the same for the month, but this time it's a bit more confusing as we want the leading zero.We can see the same basics in the middle, of selecting only the month, from the current date plus 3 months, but this is also wrapped in a function that will add 0 to the beginning of the string returned by month, but truncated to the 2 right-most characters. This means if the month returns '11', we add 0 to make '011' and then select the two right-most characters leaving just '11', however if the month is 3, we add 0 to make '03', and then select the two right most characters, leaving '03'.

The day is yet more complicated, as we have elements of both of the above:We have the same functionality to add the leading zero to the day that is returned, but finding the last day of the month is slightly tricky. From the middle out, we start by making a date equal to the first of this month:dateSerial() creates a date given 3 parameters, for year, month and day. dateSerial(Year, Month, Day)
For the year and month, we can just use the values from the current date, the day we hardcode to 1.

Once we have produced this date, we add 4 months, to give us the 1st of the month after you want the last day of.We can then subtract one day, using dateAdd, to give us the last day of the month before.

Perfect -thank you very much. This helps a lot!

Duplicate post, sorry!

Hello,
I wanted to create a filename that would adjust the date based on the current weekday. I have a report that is run for data 10 days in the future on Monday -Wednesday and 12 days in the future on Thursdays and Fridays. So, on M-W, it would be filename_yyyymmdd + 10 days, on Th-F, filename_yyyymmdd + 12 days.
Any help is appreciated. Thank you.

Hi,
We’ve the Logicity Professional version and we buy it to be able to use variables with Parameters.

The problem is, we’ve a report that need to be sent to email addresses, but each report will contain information that we want to send only to the person that correspond to the email address.

For example, the report will be generated with my information, and after that, will be sent to my own email address, and so on and so on.
At the moment, Logicity seems to not be able to send to dynamic email addresses any kind of action.

There’s any way to do it?

We also would like to know what's the variable that can be used for usernames. We're on the same report, the username that will be always different and we want to type a variable to allow dinamic usernames.

Thanks